Nick Korna
Nick Korna
Reactions
-
Re: How to construct a multi sheet tracking log?
Hi @Z.Win You can do this on a single sheet, with a second as a log if you so wish. Set up your sheet along the lines of: The Count column is a simple formula: =COUNTIF(Checkbox:Checkbox, 1) You can …1 · -
Re: How do I return a cell value if a cell contains text from another cell?
@Drey, Alter your formula slightly to use @cell in the CONTAINS portion of your formula: =JOIN(COLLECT({Reference A}, {Reference B}, CONTAINS([Product A]@row, @cell)), ", ") This should giv…1 · -
Re: NEED HELP WITH INDEX/MATCH! Tried EVERYTHING!
Hi @FMV, Your INDEX MATCH should be along the lines of this (using Property Name as an example): =INDEX({Property Name}, MATCH([Project ID]@row, {Project ID}, 0), 1) The Property Name cross sheet ran…1 · -
Re: Green, Yellow, Red Formula
Hi @Andrew Skaggs, That would depend if you want the yellow to appear if only 1 of the 2 (Job #) is blank or both: For the former (Symbol column): =IF([Job Number]@row = [Job #]@row, "Green"…1 · -
Re: Look for matching fields in multiple Smartsheet's and return an adjacent field.
There may be some bracket count errors here, but hopefully this at least will get you pointed in the right direction... =IFERROR(INDEX({No Action[s] Range 3}, MATCH([AIE-ID#]@row, {No Action[s] Range…1 ·
